Decision Analysis for Managers: A Guide for Making Better Personal and Business Decisiones by David Charlesworth

Author:David Charlesworth [Charlesworth, David]
Language: eng
Format: epub, pdf
Publisher: Business Expert Press
Published: 2017-04-11T05:00:00+00:00

Styles

The Microsoft Office suite allows you to define Styles for files produced by each application. Like range names, styles can add clarity within Excel—you can use them to define consistent fonts, colors, shading, number formats, and lines for a specific type of cells. For example, I always create a style called “InputBox” that I use for each input within the workbook (the newer versions of Excel contain a preformatted style for Inputs). This way, places to enter numbers are clear on the worksheet page.

However, like range names, you want to use a few styles and keep their significance clear.

When I was consulting, a client gave me one of their models to work on that was very slow in recalculating. I started looking at it and found that it had over 1400 styles being used! I wrote a VBA (Visual Basic for Applications) macro to delete styles and added back in about 10 that were actually useful. The model performed correctly after that adjustment.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.